/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-04-29 17:45:12
*/


-- ----------------------------
-- Table structure for tb0109
-- ----------------------------
DROP TABLE [dbo].[tb0109]
GO
CREATE TABLE [dbo].[tb0109] (
[VoucherID] varchar(20) NOT NULL ,
[BatchID] varchar(20) NULL ,
[VoucherTypeID] varchar(20) NULL ,
[TranMonth] int NULL ,
[TranYear] int NULL ,
[DivisionID] varchar(20) NULL ,
[VoucherDate] datetime NULL ,
[VoucherNo] varchar(20) NULL ,
[ObjectID] varchar(20) NULL ,
[ProjectID] varchar(20) NULL ,
[OrderID] varchar(20) NULL ,
[WareHouseID] varchar(20) NULL ,
[ReDeTypeID] varchar(20) NULL ,
[KindVoucherID] int NULL ,
[WareHouseID2] varchar(20) NULL ,
[Status] tinyint NOT NULL DEFAULT ((0)) ,
[EmployeeID] varchar(20) NULL ,
[Description] nvarchar(250) NULL ,
[CreateDate] datetime NULL ,
[CreateUserID] varchar(50) NULL ,
[LastModifyUserID] varchar(50) NULL ,
[LastModifyDate] datetime NULL 
)


GO

-- ----------------------------
-- Indexes structure for table tb0109
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table tb0109
-- ----------------------------
ALTER TABLE [dbo].[tb0109] ADD PRIMARY KEY NONCLUSTERED ([VoucherID])
GO

-- ----------------------------
-- Checks structure for table tb0109
-- ----------------------------
ALTER TABLE [dbo].[tb0109] ADD CHECK (([VoucherID] IS NOT NULL AND [VoucherID]<>''))
GO
